 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spShippingStatusReportGetNextReq]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spShippingStatusReportGetNextReq]
GO

	

CREATE PROCEDURE spShippingStatusReportGetNextReq
@OfficeID int
AS


SELECT MAX(REQ) + 1	
FROM
	[ShippingStatusReport] 
WHERE OfficeID = @OfficeID



GO

	
 